<?php

$debug=0;
$dbhost = "localhost";
$dbuser = "fossilplot";
$dbpass = "fossilplot";
$dbname = "fossilplot";
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
//Select Database
mysql_select_db($dbname) or die(mysql_error());
// Retrieve data from Query String
//$searchtxt = $_GET['searchtxt'];

//echo "hello H".$searchtxt."<br>";
$result = mysql_query("select genus_name from fossilplot.genus")
 or die ("It is not an valid SQL query, please check your query and search again.");
echo "<SELECT NAME=\"H\" id='H' multiple size=\"15\" style=\"width: 215px;\">";
while ($row = mysql_fetch_array($result)) {
	echo "<option>".$row{'genus_name'}."</option>";
	
}

echo "</select>";

?>